package com.fs.jzzn.pojo;

import javax.persistence.Entity;
import javax.persistence.Table;

import com.fs.base.pojo.PkEntity;

import lombok.Data;
import lombok.EqualsAndHashCode;

/**
 * 入库/出库物料明细
 */
@Entity
@Table(name="p_storage_item")
@Data@EqualsAndHashCode(callSuper=false)
public class StorageItem extends PkEntity{
	private String billNo;			//入库编号
	private String pNo;				//项目编号
	private String contractNo;		//订单编号
	private String roadNo;			//路段编号/立项编号，对应Project中的pNo	
	
	private String warehouseName;	//仓库名称
	private Integer mCount;			//数量
	private String location;		//库位
	private String mNo;//物料编码-唯一性
	private String mName;//物料名称
	private String mType;//物料规格
	private String mUnit;//单位
	private String mKind;//物料类别
	
	private String stockId;	//库存记录主键
	
	/*private String mNo;		//物料编号
	private Double mCount;//入库数量
	private String location;//库位
	
	@Formula("(select p.m_name from p_materiel p where p.m_no = m_no  limit 1)")
	private String mName;	//物料名称
	
	@Formula("(select p.m_type from p_materiel p where p.m_no = m_no  limit 1)")
	private String mType;//物料规格
	
	@Formula("(select p.m_unit from p_materiel p where p.m_no = m_no  limit 1)")
	private String mUnit;//物料单位*/
	
	private String inOrOut;//进或出 in-进/ out出
}
